OraFAQ Forum: Performance Tuning » Do Remote Table use Remote indexes ?

Home » RDBMS Server » Performance Tuning » Do Remote Table use Remote indexes ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do Remote Table use Remote indexes ? [message #65723]

Wed, 15 December 2004 03:36

Gerald
Messages: 54
Registered: January 2001

Member

Dears,

I'm tunning an SQL query like

Select (...) FROM owner.table1@remotebase�TAB1

and�I want to HINT with index_combine,

Select /*+ index_combine (tab1) (...) FROM owner.table1@remotebase�TAB1

my question is would it use remote indexes ?

or should i put something like that?

Select /*+ index( tab1 Owner.tab1_index01@remotebase Owner.tab1_index02@remotebase�Owner.tab1_index03@remotebase) (...)/* FROM owner.table1@remotebase�TAB1

�

�

�

Report message to a moderator

Re: Do Remote Table use Remote indexes ? [message #65727 is a reply to message #65723]

Wed, 15 December 2004 22:03

K. Prakash babu
Messages: 46
Registered: July 2001

Member

Select /*+ index_combine (tab1) (...) FROM owner.table1@remotebase TAB1........is the right one

Report message to a moderator

Re: Do Remote Table use Remote indexes ? [message #65782 is a reply to message #65723]

Thu, 23 December 2004 03:16

Milind Deshpande
Messages: 93
Registered: May 2004

Member

Hi,

Try /*+DRVING_SITE(
)*/ hint on the remote table in the query. This might help.

Regards

Milind.

Report message to a moderator

Previous Topic:	FROM and WHERE clause
Next Topic:	Improving a "DISTINCT" query on a column with skewed data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 18 04:04:18 CDT 2026